Retrieving Object and Record Information

Once a database row is defined, each column can show attached record data and object attributes. Each sub-row cell displays the information requested while the total number of objects found is displayed in the database row. If the column returns numerical data, the sum is shown in the database row. Information found in each column can be sorted using the ascending, descending, and summarize buttons; see Worksheet Commands.

Retrieving Object Attributes

To retrieve object information in a database row:

1.	Click the database row cell where the formula will be entered.

2.	In the worksheet Formula bar, enter an equal sign (=), and then enter the criteria to display (such as =(t=wall)).

The following search criteria codes can be manually entered. These same codes are placed in a formula, with proper parentheses and syntax, by the Database Criteria dialog box.

 

Criteria Name	Code	Criteria Name	Code
Arrowhead	ar	Class Name	c
Every Object	all	Fill Background	fb
Fill Foreground	ff	Fill Pattern	fp
Layer Name	l	Line Style	pp
Line Weight	lw	Object Name	n
Object Record	r	Object Type	t
Pen Background	pb	Pen Foreground	pf
Pen Pattern	pp	Selected Status	sel
Symbol Name	s	Visibility	v

3.	Click the green check mark to validate the entry.

Retrieving Record Information

To retrieve record information in a database row:

1.	Click the database header cell where the formula will be entered.

2.	In the worksheet Formula bar, enter an equal sign (=) and then enter the record information to display. The syntax for retrieving record information is:

 

Syntax	Example
record name.field name	=Furniture.Type

A period (.) must separate the two names or the formula will not be executed.

If the name of the record format or field name contains spaces, then the name must be enclosed with single quotes such as in the following example: =Trees.‘Growth Rate’

3.	Click the green check mark to validate the entry.